[. . . ] TI
TI-89/TI-92 Plus/VoyageTM 200 CellSheetTM
How To. . .
Navigate in Spreadsheets Cut, Copy, and Paste Format Spreadsheets Select, Insert, or Delete
Manipulate Data
Enter Data Sort Data Use Statistics Edit Data Plot Data Import and Export Data
Examples
Sort by Key Column Interest and Principal Paid Linear Regression Maximum Area
More Information
Customer Support Menu Map Error Messages Key Shortcuts
2/7/02
© 2001, 2002 Texas Instruments
Important Information
Texas Instruments makes no warranty, either expressed or implied, including but not limited to any implied warranties of merchantability and fitness for a particular purpose, regarding any programs or book materials and makes such materials available solely on an "as-is" basis. In no event shall Texas Instruments be liable to anyone for special, collateral, incidental, or consequential damages in connection with or arising out of the purchase or use of these materials, and the sole and exclusive liability of Texas Instruments, regardless of the form of action, shall not exceed the purchase price of this product. Moreover, Texas Instruments shall not be liable for any claim of any kind whatsoever against the use of these materials by any other party. The instructions in this guidebook refer to this Flash application only. [. . . ] Note: When AutoCalc is set to NO, cells with new formulas that you create will display a value determined using the current values in the other cells. Because the current cell is the only one that is evaluated, other cells may be incorrect. Default Setting YES
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 46
Field Name Cursor Mvmt
Description Controls the direction that the cursor moves after you press Í on the edit line. Select 1:DOWN, 2:RIGHT, or 3:OFF.
Default Setting DOWN
Show
Controls what information is displayed on the edit line formulas or resultant values. If you have chosen to show values and a selected cell contains a formula, the formula displays on the edit line when you press ¸ so that you can edit it. Select 1:FORMULA or 2:VALUE.
FORMULA
Formatting a column Formatting selected columns changes the way that data is viewed. 8:Column Format, and then change any of the following settings in the COLUMN FORMAT dialog box. Changes apply only to the current spreadsheet.
Field Name Column Description The column you wish to format. Default Setting The column(s) currently selected
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 47
Field Name Display Digits
Description Determines how many digits, up to 12, are displayed in the column. The default is FLOAT 6, which means that results are rounded to a maximum of six digits. Changing the mode screen setting does not affect data displayed in the CellSheetTM App. Determines how many characters are displayed in the column's cells. Choose 1:DEFAULT, 2:LEFT, or 3:RIGHT.
Default Setting FLOAT 6
Col Width
6
Justification
Numeric values are right-justified in the cell; text is left-justified.
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 48
Blank Cells
If a blank cell is referenced directly in a formula, it is treated as a 0 (zero). For example, if A1 is blank and A2 contains the formula =A1x2, A2 will evaluate to 0 (zero). If a range of cells contains a blank cell, the blank cell is ignored in calculations. A4 evaluates to 2.
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 49
Archiving Spreadsheets
You cannot change cell entries or format settings in an archived spreadsheet. Press 8:Archive Variable.
Note Archived and locked spreadsheets can be opened for viewing purposes only. Only unarchived/unlocked spreadsheets can be opened for editing.
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 50
Key Shortcuts
Press B:Help for a help screen showing navigation, selecting, and editing key shortcuts.
To. . . Enter a value or symbolic expression in a cell Enter a formula in a cell
Do this. . . From a selected cell, press Á if you need the cell content to be updated. Press ¸.
Enter a string (text) in a cell
TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App
Page 51
To. . . If the variable has the same name as a cell or if it is in a different folder, include the path name. [. . . ] 16 Entering Symbolic Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Formulas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ]